Excel 2016 - Formulas and Referencing, Working with Functions and Named Ranges
      The "Excel 2016 - Formulas and Referencing, Working with Functions and Named Ranges" lesson covers the following topics:
  • Formulas and Referencing
  • Working with Functions
  • Named Ranges
      
      Formulas and Referencing      
      Upon successful completion you will be able to:

1. Identify Formula Operators;
2. Understand Operator Precedence;
3. Over-ride Operator Precedence;
4. Enter Formulas;
5. Copy Formulas;
6. Use AutoFill;
7. Update Formula Results;
8. Use Absolute References;
9. Apply Percentage Values.
      
      Working with Functions      
      Upon successful completion you will be able to:

1. Identify Function Components;
2. Enter Functions;
3. AutoSum Numbers;
4. Use the AutoSum List;
5. Use the ROUND Function;
6. Apply the IF Function.		      
      Named Ranges      
      Upon successful completion you will be able to:

1. Name Cells;
2. Name Cell Ranges;
3. Add to and Edit Named Ranges;
4. Change Range Names;
5. Use Go To;
6. Navigate using Cell Names;
7. Use Names in Formulas;
8. Display Cell Formulas;
9. Delete Named Ranges.

      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2016 - Formulas and Referencing, Working with Functions and Named Ranges :
Program Training Courses - Microsoft Excel 2016 :
Office Suite Training Courses - Microsoft Office 2016 :
© 2017 Online Training Masters